﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$" formatter="bizobjlist of User">
	<Sql>
		SELECT 
			u.id,u.userName as useruserName,u.companyId,u.enable
		FROM 
			Users u 
		LEFT JOIN 
			UserGroupLink l ON u.id = l.userId 
		WHERE 
			u.companyId=@companyId
    ORDER BY
      u.userName
	</Sql>
	
	<Param name="companyId" type="UniqueIdentifier"/>
</AdoNetDataAccess>